Federal Assistance Awards Data System currently does not display a single recipient of assistance across multiple records (i.e., one entry that would list multiple awards for the same recipient). Assistance data is currently aggregated based on the textual information provided by the reporting agency.
USAspending.gov attempts to regularize the recipient names by discarding some punctuation, removing words like "Co." or "Inc.", and standardizing certain abbreviations. Then, all records with the same regularized recipient name and recipient state are assumed to belong to the same recipient. A single overall recipient name is chosen for this group of records, based on the most commonly occurring name within the un-standardized recipient names for the group ( This mappings for all regularization done by USAspending.gov is available at this mapping list ).
This method of grouping records by recipient name and state has some disadvantages. It may, for instance, treat a multi-state recipient as being more than one entity, thereby listing the same group twice in different states, or it may group unrelated entities together that happen to have the same name within the same state. But, the advantages of a common recipient name to enable aggregate totals across records outweigh the problems.
As a final step, the names of many recipients were standardized from the original federal data. State agencies, for instance, now begin with the name of the state fully spelled out. So the original recipient name of NC ST DEPARTMENT OF HEALTH & HUMAN SERVICE, for example, was changed to NORTH CAROLINA DEPT OF HEALTH & HUMAN SERVICES. This should make searches easier and subtotals more meaningful.
Sometimes Federal Assistance Awards Data System marks information as being either corrections to data for a previous fiscal year or as late filings for a previous fiscal year. To give the proper scope of federal spending in any given fiscal year, we have displayed this data as being part of the fiscal year that the transactions were updated/modified, not as part of the fiscal year in which the transactions were originally reported.
The Federal Assistance Awards Data System's categorization of what type of entity receives assistance (e.g., individual, state government, private higher education), and how the assistance is delivered (e.g., direct payment, loan, block grant), includes too many values to be conveniently displayed on USAspending.gov. Therefore, we have grouped the original recipient types and assistance type into streamlined summary categories. Users can access the detailed categories that the Federal Assistance Awards Data System uses by selecting the "Complete (all information)" level of detail option available for all data output. The USAspending.gov groupings for recipient type and assistance type are detailed in the two charts below:
USAspending.gov recipient category | Federal Assistance Awards Data System recipient type |
---|---|
government | state government |
government | county government |
government | city or township government |
government | special district government |
government | independent school district |
higher ed | State controlled institution of higher education |
government | Indian tribe |
nonprofit | other nonprofit |
higher ed | private higher education |
individual | individual |
for profit | profit organization |
for profit | small business |
other | all other |
USAspending.gov assistance category | Federal Assistance Awards Data System assistance type |
---|---|
grants and co-op. agreements | block grant |
grants and co-op. agreements | formula grant |
grants and co-op. agreements | project grant |
grants and co-op. agreements | cooperative agreement |
direct payments (both specified and unspecified) | direct payment for specified use, as a subsidy or other non-reimbursable direct financial aid |
loans (both direct and guaranteed) | direct loan |
loans (both direct and guaranteed) | guaranteed/insured loan |
insurance | insurance |
direct payments (both specified and unspecified) | direct payment with unrestricted use (retirement, pension, veterans benefits, etc.) |
other | other reimbursable, contingent, intangible, or indirect financial assistance |
The Catalog of Federal Domestic Assistance (CFDA) Program (www.cfda.gov) is a database that classifies all federal programs that provide funding to local government agencies, private institutions, and individuals. Each program is assigned a number and name. Most of the time, CFDA program numbers match with associated program titles. However, there are instances of CFDA program numbers being reported by agencies that are not listed in the current CFDA program list.
This is a list of all of the data fields received by USAspending.gov from agencies as part the agency’s federal assistance award reporting (per OMB memoranda M-09-19). This can be used to see what kind of data each field displayed in the extensive or complete levels of detail contains. The "Field Type" column provides the type and size of the field in case you wish to load USAspending.gov data into your own database.
This section shows information about the recipient of the award, such as the name, location, and type of the recipient.
Data Field | Description | Field Type |
---|---|---|
Recipient Name | The name of the recipient of the award. | varchar(45) |
Recipient City Code | The five-digit FIPS city code for the city in the address of the recipient of the award. | varchar(5) |
Recipient City Name | The city in which the address of the recipient of the award is located. | varchar(21) |
Recipient County Code | The three-digit FIPS county code or ANSI INCITS county code for the county in which the address for the recipient of the award is located. | char(3) |
Recipient County Name | The county in which the address for the recipient of the award is located. | varchar(21) |
Recipient State Code | The two-digit FIPS or INCITS state code for the state or territory in which the address for the recipient of the award is located. | char(2) |
Recipient State Name | The name of the state or territory in which the address for the recipient of the award is located. | varchar(25) |
Recipient Zip Code | The Zip code in the address of the recipient of the award. | varchar(9) |
Congressional District | The Congressional District of the recipient, modified by USAspending.gov to fix some bad data and to use a 2-letter state followed by 2 digit format. 90 means not known, 00 means at large or statewide, 98 means nonvoting, 99 means no representative. | varchar(4) |
Recipient Congressional District | The Congressional district in which the address of the recipient of the award is located. 90 indicates district not known, 00 at-large or statewide, 98 nonvoting, 99 no representative. | char(2) |
Recipient Category | The original Federal Assistance Awards Data System recipient type code, modified by USAspending.gov into a set of broader categories (government, individual, nonprofit, for profit, higher ed, other). | char(1) |
Recipient Type | The type of recipient (i.e., state government, local government, Indian tribe, individual, small business, for-profit, nonprofit, etc.) | char(2) |
Recipient Address Line 1 | Recipient 's Full address Line 1 | char(35) |
Recipient Address Line 2 | Recipient 's Full address Line 2 | char(35) |
Recipient Address Line 3 | Recipient 's Full address Line 3 | char(35) |
Recipient DUNS Number | Unique nine-digit number issued by Dun & Bradstreet (D&B) to a single business entity. Assigned to each business location in the D&B database having a unique, separate, and distinct operation for the purpose of identifying it. Followed by optional DUNS Plus 4 which allows an agency to submit different bank account data for a single DUNS. | char(13) |
Dun & Bradstreet Confidence Code | Optional data field to enter the D&B Confidence Code received for validated DUNS data (As provided to agencies by Dun & Bradstreet when obtaining DUNS). OMB encourages Agencies to submit this code with their file submissions to affirm the accuracy of data validated through the D&B process. | char(2) |
Recipient Country Code | The ISO or FIPS code for the country in which the recipient of the award is located. | char(3) |
This section shows information about which agency granted the award under what governmental program, and provides some ID numbers for the award.
Data Field | Description | Field Type |
---|---|---|
Agency Code | A code indicating which governmental agency or bureau provided the award. | varchar(4) |
Agency Name | The name of the governmental agency or bureau that provided the award. | varchar(72) |
Federal Award ID | An agency-specific unique ID number for each individual assistance award. There may be more than one action record per assistance award, because of continuations, revisions, funding adjustments, corrections, etc. | varchar(16) |
Federal Award ID Modification | A modification number used to indicate action records that modify a previous action record with the same federal award ID. | varchar(4) |
State Application ID Number | A number assigned by state (as opposed to federal) review agencies to the award during the grant application process. | varchar(20) |
CFDA Program Number | The numeric code that indicates the program under which this award was funded within the Catalog of Federal Domestic Assistance (CFDA). Numbers that contain AAA, AAB etc. are pseudo-codes and are not in CFDA. | varchar(7) |
CFDA Program Title | The title of the program under which the award was funded, taken from the Catalog of Federal Domestic Assistance (CFDA). | varchar(74) |
Assistance Category | The original Federal Assistance Awards Data System assistance type code, modified by USAspending.gov into a set of broader categories (direct grants, loans, insurance, etc.) | char(1) |
Assistance Type | The type of assistance provided by the award: whether it is a grant, cooperative agreement, direct payment, loan, insurance, etc. | char(2) |
Program Source/Treasury Account Symbol: Agency Code | Agency Code part (First 2 characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury | varchar(2) |
Program Source/Treasury Account Symbol: Account Code | Account Code part (3rd to 6th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury | varchar(4) |
Program Source/Treasury Account Symbol; Sub-Account Code (OPTIONAL) | Sub-Account Code part (7th to 9th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury | varchar(3) |
Business Funds Indicator (BFI) | Distinguisher for different fund types, such as the funding provided by the Recovery Act. | char(3) |
Unique Record Identifier (URI) | An agency defined identifier that is unique for every reported action. | varchar(70) |
This section shows a detailed action taken under the award -- an amount of money granted or subtracted, the dates involved, the fiscal quarter, and the type of action.
Data Field | Description | Field Type |
---|---|---|
Fiscal Year | The fiscal year in which the award occurred. It may be different from the fiscal year of the award record if the record is a late filing or correction of an amount for a prior fiscal year. Data field added by USAspending.gov. | smallint(6) |
Fiscal Year / Quarter | The fiscal year and fiscal year quarter for this record, with the first four digits being the year, the fifth the quarter. | varchar(5) |
Action Type | The type of action for the record: whether it is a new assistance action, a continuation, a revision, or a funding adjustment. | char(1) |
Federal Funding Amount | Amount of federal government's obligation or contingent liability, in dollars. A negative number represents a decrease in funding. | int(11) |
Non-Federal Funding Amount | Amount of non-federal funding, in dollars. A negative number represents a decrease in funding. | int(11) |
Total Funding Amount | The total federal plus non-federal funding amount in dollars. A negative number represents a decrease in funding. | int(12) |
Face Value of Direct Loan/Loan Guarantee | The face value of the direct loan or loan guarantee | bigint(16) |
Original Subsidy Cost of the Direct Loan/Loan Guarantee | The original subsidy cost of the direct loan or loan guarantee | bigint(16) |
Obligation / Action Date | Obligation or action date for the award. | date |
Starting Date | The starting date for the award. | date |
Ending Date | The ending date for the award. | date |
Record Type | Federal Assistance Awards Data System record type: 1 = county aggregate record, 2 = individual action record | char(1) |
Correction / Late Indicator | Indicates that the action record is either a correction of a record from a previous quarter or a late reported record from a previous quarter. The previous quarter is indicated in the Corrected Fiscal Year / Quarter data field. | char(1) |
Corrected Fiscal Year / Quarter | The fiscal year (first four digits) and quarter (fifth digit) of the previous fiscal year and quarter that this record corrects, or which it is a late report for. | varchar(5) |
This section shows the principal place of performance of the activity supported by the award.
Data Field | Description | Field Type |
---|---|---|
Principal Place Code | A code for the principal place of performance for the award. The first two digits are the state FIPS code, the next five the county FIPS (three digits followed by **) or city FIPS code. 00***** = multi-state, 00FORGN = foreign country. | varchar(7) |
Principal Place State | The state or territory name of the principal place of performance for the award. | varchar(25) |
Principal Place County or City | The city or county name of the principal place of performance for the award. | varchar(25) |
Principal Place of Performance Zip Code | The 9 digit zip code (zip+4) of the principal place of performance for the award. | varchar(9) |
Principal Place of Performance Congressional District | The Congressional District of the principal place of performance for the award. | varchar(2) |
Principal Place of Performance Country Code | The ISO or FIPS code for the country of the principal place of performance for the award. | char(3) |
The most basic task that many users want to accomplish is to look up a particular contractor and find out which contracts they have received. This makes the most sense if done by parent company -- the entity that owns multiple divisions, "doing business as" names, or subsidiaries that may show up as individual contractor names.
USASpending.gov uses information provided by Dun & Bradstreet to determine the parent company information based on the date USASpending.gov receives the transaction from the Federal Procurement Data System. The parent company name provided by Dun & Bradstreet is used throughout the site for purposes of searching and browsing contract transactions. However, the specific contractor name is always displayed in the Complete Details page for each transaction.
Some errors may exist in these parent company assignments, so that transaction records that really apply to different contractors are grouped together. In cooperation with Duns & Bradstreet, we will periodically fix any such errors that are brought to our attention.
This is a subset of all of the data fields provided by the Federal Procurement Data System (FPDS) (the federal contracts database). The full FPDS data dictionary can be found at www.fpds-ng.com
This section shows dollar amounts of awards.
Data Field | FPDS Screen Name | FPDS Element Number | Description/FPDS Definition | Field Type |
---|---|---|---|---|
Dollars Obligated | Action Obligation | 3C | The net dollar amount that is obligated or de-obligated by this transaction. If the net is a de-obligation, the amount will be negative. | double(18,2) |
Current Contract Value | Base And Exercised Options Value | 3B | The contract value for the base contract and any options that have been exercised. | double(18,2) |
Ultimate Contract Value | Base And All Options Value | 3A | It is the mutually agreed upon total contract or order value including all options (if any). For Indefinite Delivery Vehicles, the estimated value for all orders expected to be placed against the vehicle. For modifications, the change (positive or negative, if any) in the mutually agreed upon total contract value. |
double(18,2) |
This section shows information about the purchaser for the award, i.e. the governmental agency or agencies that made the purchase.
Data Field | FPDS Screen Name | FPDS Element Number | Description/FPDS Definition | Field Type |
---|---|---|---|---|
Contracting Agency | Agy, Contracting Office Agency ID | 4A | A code for the governmental agency or bureau that executed or is otherwise responsible for the transaction. | varchar(4) |
Contracting Office | Contracting Office ID | 4B | The agency supplied code for the contracting office that executes the transaction. | varchar(6) |
Program / Funding Agency | Funding Agency ID | 4C | A code for the agency that provided the preponderance of the funds obligated by this transaction. If left blank, defaults to Contracting Agency. | varchar(4) |
Program / Funding Office | Funding Office | 4D | The agency provided code that identifies the office that provided the preponderance of funds. If the Funding Agency is a DoD agency, the code is the DoD Activity Address Code (DODAAC). | varchar(6) |
Reason For Purchase For DoD | A code that indicates why a civilian agency made a purchase for DoD. | char(1) | ||
Funded by Foreign Government or International Org. | Foreign Funding | 4F | Indicates that a foreign government, international organization, or foreign military organization bears some of the cost of the acquisition. | char(1) |
Program Source/Treasury Account Symbol: Agency Code | Agency Identifier | 6SC | Agency Code part (First 2 characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury | varchar(2) |
Program Source/Treasury Account Symbol: Account Code | Main Account | 6SG | Account Code part (3rd to 6th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury | varchar(4) |
Program Source/Treasury Account Symbol; Sub-Account Code (OPTIONAL) | Sub Account | 6SH | Sub-Account Code part (7th to 9th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury | varchar(3) |
Business Fund Indicator | Initiative | 6SI | Distinguisher for different fund types, such as the funding provided by the Recovery Act. | char(1) |
This section shows basic contract information for an award.
Data Field | FPDS Screen Name | FPDS Element Number | Description/FPDS Definition | Field Type |
---|---|---|---|---|
Date Signed | Date Signed | 2A | The date that a mutually binding agreement was reached. The date signed by the Contracting Officer or the Contractor, whichever is later. | date |
Effective Date | Effective Date | 2B | The date that the parties agree will be the starting date for the contract's requirements. Usually, this is the same as the date signed, but may be different. | date |
Current Completion Date | Completion Date | 2C | The current expected or scheduled contract completion date, based on the initial schedule, any options exercised at the time of the award, and any modifications made later. | date |
Ultimate Completion Date | Est. Ultimate Completion Date | 2D | The estimated or scheduled completion date including the base contract or order and all options (if any) whether the options have been exercised or not. | date |
Award Type | Award Type | 12B | The type of award for this record. Types of awards include Purchase Orders (PO), Delivery Orders (DO), BPA Calls and Definitive Contracts. | char(1) |
Reason For Modification | Reason for Modification | 12C | Code for the type of modification to an award or IDV performed by this transaction. | char(1) |
Type of Contract Pricing | Type of Contract | 6A | The type of contract as defined in FAR Part 16 that applies to this procurement. Can be fixed price, cost plus, labor hours, etc. | char(1) |
Undefinitized Action | Undefinitized Action | 6B | Indicates whether the award is a Undefinitized Action. | char(1) |
Multi-Year Contract | Multi Year Contract | 6C | Indicates whether this is a multi-year contract, a contract for the purchase of supplies or services for more than 1, but not more than 5, program years. Such contracts are issued under specific congressional authority for specific programs. | char(1) |
Performance-Based Service Contract | Performance Based Service Acquisition | 6F | Indicates whether the contract is a Performance-Based Service Acquisition (PBSA) as defined by FAR 37.601. A PBSA describes the requirements in terms of results rather than the methods of performance of the work and has other detailed requirements. | char(1) |
Major Program | Major program | 6G | The agency determined code for a major program within the agency. For an Indefinite Delivery Vehicle, this may be the name of a GWAC (e.g., ITOPS or COMMITS). | varchar(100) |
Contingency, Humanitarian, or Peacekeeping Operation | Contingency, Humanitarian, or Peacekeeping Operation | 6H | Indicates contract actions that exceed $200,000 and support a contingency operation, a humanitarian operation, or a peacekeeping operation. | char(1) |
Cost or Pricing Data DoD | Cost or Pricing Data | 6J | Indicates whether cost or pricing data was obtained, not obtained, or waived for DoD assigned contracts. | char(1) |
Contract Financing | Contract Financing | 6K | Type of financing used to effect payment (progress payments, advance payments, etc.). | char(1) |
Cost Accounting Standards Clause | Cost Accounting Standards Clause | 6L | Indicates whether the contract includes a Cost Accounting Standards clause. | char(1) |
Contract Description | Description of Requirement | 6M | A brief description of the goods or services bought (for an award) or that are available (for an IDV). | text |
Purchase Card As Payment Method | Purchase Card Used As Payment Method | 6N | Indicates whether the method of payment under an award is the Purchase Card. Agencies may issue formal contract documents and make payment using the Purchase Card. It is also permitted that agencies may report Purchase Card purchases. | char(1) |
Number of Actions | Number of Actions | 6Q | The number of actions that involved contract modifications for additional supplies or services. Can be reported for new contracts or contract modification transactions. Data fields exists in XML schema version 1.2 and later only. | int(11) |
National Interest Action | National Interest Action | 6R | Code for contracts created in response to "national interests" (e.g. Hurricane Katrina, Hurricane Rita). Note: data field only exists in XML schema version 1.2 and later. | varchar(4) |
This section shows basic information about the contractor/vendor for an award, such as its name, address, parent, and contact information.
Data Field | FPDS Screen Name | FPDS Element Number | Description/FPDS Definition | Field Type |
---|---|---|---|---|
Vendor Name | Name | 13GG | The name of the vendor awarded the contract as it appears in CCR or as entered by the user if CCR exception is selected. | varchar(100) |
Vendor Doing Business As Name | DBAN | 13HH | The doing as business name of the contractor address. | varchar(80) |
Vendor Name from Contract | The name of the contractor supplying the product or service as it appears on the contract. | varchar(80) | ||
CCR Exception | CCR Exception | 9J | Indicates and gives the reason why a vendor/contractor not registered in the mandated Central Contractor Registry (CCR) system may be used in a purchase. Data field only exists in XML schema version 1.1 and later. | char(1) |
Vendor Address Line 1 | Street | 13JJ | The first line of the street address for the contractor. | varchar(55) |
Vendor Address Line 2 | Street2 | 13KK | The second line of the street address for the contractor. | varchar(55) |
Vendor Address Line 3 | Street3 | 13LL | The third line of the street address for the contractor. | varchar(55) |
Vendor Address City | City | 13MM | The city of the contractor address. | varchar(35) |
Vendor Address State | State | 13NN | The state in the contractor address. | char(2) |
Vendor Zip Code | Zip | 13PP | The zip code in the contractor address. | varchar(10) |
Vendor Country | Country | 13QQ | The country code in the contractor address. | varchar(20) |
Vendor Congressional District | Congressional District Contractor | 9F | The Congressional district of the contractor, as derived from the Zip+4 in the contractor address. | varchar(6) |
Vendor DUNS Number | DUNS No | 9A | The Dun & Bradstreet number of the vendor. This is used to link records to the Central Contractor Registry (CCR) and only exists for vendors in the CCR. | varchar(13) |
Vendor Phone Number | Phone | 13RR | The phone number of the contractor. | varchar(20) |
Vendor Fax Number | Fax | 13SS | The fax number of the contractor. | varchar(20) |
Parent ID | A unique ID assigned by USAspending.gov to each parent company, so that records can be grouped by parent company. | bigint(20) | ||
Parent Company Name | The parent company for the vendor, as provided by D&B. | varchar(100) |
This section shows the principal place of performance of the award -- the place where most of the work was done.
Data Field | FPDS Screen Name | FPDS Element Number | Description/FPDS Definition | Field Type |
---|---|---|---|---|
Place of Performance Code | Principal Place of Performance Code (State, Location, Country) | 9C | The code from the combined FIPS Pub. 10 and FIPS Pub. 55 that identifies the place where the work is being performed. | varchar(5) |
Place of Performance State | Principal Place of Performance Code (State, Location, Country) | 9C | The U.S. state that is the principal place where the work was / is performed. | char(2) |
Place of Performance Country | Principal Place of Performance Code (State, Location, Country) | 9C | The country that is the principal place where the work was / is performed. | char(3) |
Place of Performance Zip Code | Zip Code Place of Performance | 9K | The Zip code of the principal place where the work was / is performed. Data field exists only in XML schema version 1.2 and later. | varchar(10) |
Place of Performance Cong. District | Congressional District Place of Performance | 9G | The Congressional district that is the principal place in which the work was / is performed. | varchar(6) |
This section shows information about the product or service purchased by the award.
Data Field | FPDS Screen Name | FPDS Element Number | Description/FPDS Definition | Field Type |
---|---|---|---|---|
Major Product or Service Code | The major category that the Federal Procurement Data System Product or Service Code for the record falls within (see page 12 of http://www.fpdsng.com/downloads/service_product_codes.pdf). | char(2) | ||
Product or Service Code | Product/Service Code | 8A | The code that best identifies the product or service procured. If more than one code applies, then the code that represents most of the ultimate contract value is reported. | varchar(4) |
DoD Program, System, or Equipment Code | System Equipment Code | 8B | Two codes that identify the program and weapons system or equipment purchased by a DoD agency. The first character is a number 1-4 that identifies the DoD component. The last 3 characters identify that component's program, system, or equipment. | varchar(4) |
DoD Claimant Program Code | Claimant Program Code | 8F | A claimant program number designates a grouping of supplies, construction, or other services. This data field may have a code from the DoD Procurement Coding Manual Section III, DoD Claimant Program Number. | char(3) |
Principal NAICS Code | Principal NAICS Code | 8G | The principal North American Industry Classification System (NAICS) code (used to designate major sectors of the economies of Mexico, Canada, and the United States) that indicates the industry in which the contractor does business. | varchar(6) |
Information Technology Commercial Item Category | InfoTech Commercial Item Category | 8H | A code that designates the commercial availability of an information technology product or service. | char(1) |
Govt. Furnished Equipment or Property | GFE/GFP Provided Under This Action | 8J | Indicates whether Government Furnished Equipment (GFE) or Government Furnished Property (GFP) used for the contract, pursuant to FAR 45. | |
Use of EPA Designated Products | Use of EPA Designated Products | 8K | Indicates whether EPA approved products with a minimum recovered material content were used, or whether an exception was made. | char(1) |
Recovered Material Clauses | Use Of Recovered Material | 8L | Indicates whether Recovered Material Certification and/or Estimate of Percentage of Recovered Material Content for EPA-Designated Products clauses were included in the contract. | char(1) |
Sea Transportation | Sea Transportation | 8M | Indicates whether the contractor anticipates that some of the supplies may be transported by sea. | char(1) |
Contract Bundling Reason | Bundled Contract | 8N | Indicates that the value of the contract, including all options, is expected to exceed $5M as a result of consolidating separate small contracts into a single contract likely to be unsuitable for a small business concern, and the reason for bundling. | char(1) |
Consolidated Contract | Consolidated Contract | 8P | Indicates whether the contract is a consolidated contract. This is only required if the Funding Agency or the contracting agency is a DoD Agency. Data field exists in XML schema version 1.2 and later only. | char(1) |
Country of Product or Service Origin | Country of Product or Service Origin | 9E | Identifies the country of origin of the product. | char(2) |
Place of Manufacture | Place Of Manufacture | 9H | Represents whether the end products procured by the contract are manufactured inside or outside the U.S. in accordance with the Buy American Act (see FAR 25.1) and any exceptions or reasons for waivers employed | char(1) |
This section shows information about a Federal Procurement Data System award record, such as its identifying IDs, which IDV it links to, its fiscal year, its version, etc.
Data Field | FPDS Screen Name | FPDS Element Number | Description/FPDS Definition | Field Type |
---|---|---|---|---|
Identifying Agency ID | Agency | 1F | Identifier used to link agency in FPDS-NG to award information. | varchar(4) |
Procurement Instrument ID | PIID | 1A | The unique identifier for each contract, agreement or order. | varchar(50) |
Modification Number | Modification Number | 1B | An identifier that uniquely identifies a modification for a contract, agreement, or order. | varchar(25) |
Transaction Number | Transaction Number | 1D | Unique identifier for each transaction for a contracting action or modification. There can be more than one in situations such as when an action includes more than one contract type. | varchar(6) |
Fiscal Year | The federal government fiscal year (starting October 1), determined by the “Signed Date” provided by FPDS. . | smallint(6) | ||
IDV Agency ID | Agency | 1H | This is a code for an agency, but it does not necessarily represent the agency that issued the contract. Instead, it serves as part of the unique identification for Federal Procurement Data System IDV records. For awards records, it partially identifies a linked IDV record. | varchar(4) |
IDV Procurement Instrument ID | Referenced IDV ID (includes the Agency ID and PIID for the associated IDV) | 1C | When reporting orders under Indefinite Delivery Vehicles (IDV) such as a GWAC, IDC, FSS, BOA, or BPA, report the Procurement Instrument Identifier (Contract Number or Agreement Number) of the IDV. For the initial load of a BPA under a FSS, this is the FSS contract number. Note: BOAs and BPAs are with industry and not with other Federal Agencies. | varchar(50) |
IDV Modification Number | Modification Number | 1G | For IDV records, uniquely identifies the modification of the contract, agreement, or order. For awards records, it partially identifies a linked IDV record. | varchar(25) |
Solicitation ID | Solicitation Identifier | 1E | Identifier used to link transactions to solicitation information. | varchar(25) |
This section shows information on how an award was procured.
Data Field | FPDS Screen Name | FPDS Element Number | Description/FPDS Definition | Field Type |
---|---|---|---|---|
Extent Competed | Extent Competed | 10A | A code that represents how the contract was competed. | char(3) |
Other than Full and Open Competition | Other than Full and Open Competition (pre CLOD - Reason Not Competed) | 10C | A code for the reason the contract was not competed -- i.e., solicitation procedures other than full and open competition pursuant to FAR 6.3. | char(3) |
Number of Offers Received | Number Of Offers Received | 10D | The number of actual offers/bids received in response to the solicitation. | smallint(6) |
Commercial Item Acquisition Procedures | Commercial Item Acquisition Procedures | 10H | Indicates whether the solicitation used the special requirements for the acquisition of commercial items intended to more closely resemble those customarily used in the commercial marketplace as defined by FAR Part 12. | char(1) |
Commercial Item Test Program | Commercial Item Test Program | 10J | Indicates whether the solicitation used Commercial Item Acquisition Procedures (FAR Part 12) and Simplified Acquisition Procedures (FAR Part 13.5) for acquisitions above the Simplified Acquisition Threshold and below $5,000,000. | char(1) |
Small Business Competitiveness Demonstration Program | Small Business Competitiveness Demonstration Program | 10K | Indicates whether the contract was awarded to a U.S. business concern as a result of a solicitation issued on or after Jan 1, 1989 as part of the Small Business Competitiveness Program (FAR Part 19.10). | char(1) |
A-76 (FAIR Act) Action | A76 Action | 10L | Indicates whether the contract action resulted from an A-76/Fair Act competitive sourcing process. | char(1) |
Solicitation Procedures | Solicitation Procedures | 10M | A code for the type of solicitation procedures used. Data field exists only in XML schema version 1.2 and later. | varchar(5) |
Type of Set Aside | Type of Set Aside | 10N | A code for the type of set aside determined for the contract action. Data field exists only in XML schema version 1.2 and later. | varchar(10) |
Evaluated Preference | Evaluated Preference | 10P | The type of preference determined for the contract action, reported when a contract was made pursuant to the socioeconomic program price evaluation preferences -- FAR 19.11 and FAR 19.13. Data field exists only in XML schema version 1.2 and later. | varchar(6) |
Research | SBIR/STTR | 10Q | A code used when the contract was awarded as part of a Small Business Innovation Research or Small Technology Transfer Research Program. Data field exists only in XML schema version 1.2 and later. | char(3) |
Fair Opportunity/Limited Sources | Fair Opportunity/Limited Sources (pre CLOD - Statutory Exception to Fair Opportunity) | 10R | A code indicating a statutory exception to Fair Opportunity, used awarding a non competitive task order or delivery order exceeding $2500.00 against an IDIQ contract. Data field exists only in XML schema version 1.2 and later. | char(3) |
This section shows characteristics of the contractor for an award, such as its size, its type, and a set of flags showing whether it is in various special categories.
Data Field | FPDS Screen Name | FPDS Element Number | Description/FPDS Definition | Field Type |
---|---|---|---|---|
Organizational Type | A code for the type of organization of the vendor. | varchar(30) | ||
Number of Employees | The contractor's business size in terms of number of employees. Usually obtained from the CCR (Central Contractor Registry). | int(11) | ||
Annual Revenue | The contractor's annual gross revenue, taken from an average of the last three years. Usually obtained from the CCR (Central Contractor Registry). | double | ||
8A Firm | Firm 8A | 13N | Indicates whether the vendor is an 8(a) Program Participant Organization. | char(1) |
Hist. Underutilized Business Zone (HUBZone) Firm | SBA Certified HUBZone | 13O | Indicates whether the vendor is a Historically Underutilized Business Zone (HUBZone) Firm. | char(1) |
Small Disadvantaged Business | Small Disadvantaged Business | 13P | Indicates whether the vendor is a Small Disadvantaged Business Organization. | char(1) |
Sheltered Workshop (JWOD Provider) | The AbilityOne Program | 13Q | Indicates whether the vendor is a Sheltered Workshop (JWOD Provider) Organization. | char(1) |
Historically Black College or University | HBCU | 13R | Indicates whether the vendor is a Historically Black College or University. | char(1) |
Educational Institution | Educational Institution | 13T | Indicates whether the vendor is an Educational Institution. | char(1) |
Woman Owned Business | Woman Owned | 13U | Indicates whether the vendor is a Woman Owned Business. | char(1) |
Veteran Owned Business | Veteran Owned | 13V | Indicates whether the vendor is a Veteran Owned Business. | char(1) |
Service Disabled Veteran Owned Firm | Service Disabled Veteran Owned Business | 13W | Indicates whether the vendor is a Service-Related Disabled Veteran Owned Business. | char(1) |
Local Government | Local Government Owned | 13ID | Indicates whether the vendor is a Local Government Organization. | char(1) |
Minority Institution | Minority Institution | 13S | Indicates whether the vendor is a Minority Institution. | char(1) |
American Indian Owned Business | American Indian | 13Y | Indicates whether the vendor is an American Indian Owned Business. | char(1) |
State Government | U.S. State Government | 13J | Indicates whether the vendor is a State Government Organization. | char(1) |
Federal Government | Federal Government | 13K | Indicates whether the vendor is a Federal Government Organization. | char(1) |
Minority Owned Business | Minority Owned Business | 13UA | Indicates whether the vendor is a Minority Owned Business. | char(1) |
Asian-Pacific American Owned Business | Asian Pacific | 13Z | Indicates whether the vendor is an Asian-Pacific American Owned Business. | char(1) |
Tribal Government | U.S. Tribal Government | 13L | Indicates whether the vendor is a Tribal Government Organization. | char(1) |
Black American Owned Business | Black Owned | 13AA | Indicates whether the vendor is a Black American Owned Business. | char(1) |
Native American Owned Business | Native American | 13CC | Indicates whether the vendor is a Native American Owned Business. | char(1) |
Subcontinent Asian (Asian-Indian) American Owned Business | Asian Indian | 13DD | Indicates whether the vendor is a Subcontinent Asian (Asian- Indian) American Owned Business. | char(1) |
Nonprofit Organization | Non-profit Organization | 13EE | Indicates whether the vendor is a Nonprofit Organization. | char(1) |
Hispanic American Owned Business | Hispanic Owned | 13BB | Indicates whether the vendor is a Hispanic American Owned Business. | char(1) |
Emerging Small Business | Emerging Small Business ("Emerging Small" future change) | 13M | Indicates whether the vendor is an Emerging Small Business. | char(1) |
Hospital | Hospital Flag | 13VV | Indicates whether the vendor is a Hospital. | char(1) |
Contracting Officer's Determination of Business Size | Contracting Officer Business Size Determination | 11A | The Contracting Officer's determination of whether the selected contractor meets the small business size standard for award to a small business for the NAICS code that is applicable to the contract. | char(1) |
Self-Certified Small Disadvantaged Business | Self-Certified Small Disadvantaged Business | 13NC | Indicates whether the vendor is a Self-Certified Small Disadvantaged Business Organization. | char(1) |
1862 Land Grant College | 1862 Land Grant College | 13RA | Indicates whether the vendor is a 1862 Land Grant College | char(1) |
1890 Land Grant College | 1890 Land Grant College | 13RB | Indicates whether the vendor is a 1890 Land Grant College | char(1) |
1994 Land Grant College | 1994 Land Grant College | 13RC | Indicates whether the vendor is a 1994 Land Grant College | char(1) |
Veterinary College | Veterinary College | 13SE | Indicates whether the vendor is a Veterinary College | char(1) |
Other Not For Profit Organization | Other Not For Profit Organization | 13EF | Indicates whether the vendor is a Other Not For Profit Organization | char(1) |
Service Provider | Service Provider | 13TG | Indicates whether the vendor is a Service Provider | char(1) |
Grants | Grants | 13XA | Indicates whether the vendor receives Grants | char(1) |
Receives Contracts and Grants | Receives Contracts and Grants | 13XB | Indicates whether the vendor receives Contracts and Grants | char(1) |
Airport Authority | Airport Authority | 13XC | Indicates whether the vendor is an Airport Authority | char(1) |
Council of Governments | Council of Governments | 13XD | Indicates whether the vendor is a Council of Governments | char(1) |
Housing Authorities Public/Tribal | Housing Authorities Public/Tribal | 13XE | Indicates whether the vendor is a Housing Authorities Public/Tribal | char(1) |
Interstate Entity | Interstate Entity | 13XF | Indicates whether the vendor is a Interstate Entity | char(1) |
Planning Commission | Planning Commission | 13XG | Indicates whether the vendor is a Planning Commission | char(1) |
Port Authority | Port Authority | 13XH | Indicates whether the vendor is a Port Authority | char(1) |
Transit Authority | Transit Authority | 13XI | Indicates whether the vendor is a Transit Authority | char(1) |
Subchapter S Corporation | Subchapter S Corporation | 13XJ | Indicates whether the vendor is a Subchapter S Corporation | char(1) |
Limited Liability Corporation | Limited Liability Corporation | 13XK | Indicates whether the vendor is a Limited Liability Corporation | char(1) |
Foreign Owned and Located | Foreign Owned and Located | 13XL | Indicates whether the vendor is Foreign Owned and Located | char(1) |
Interagency Contracting Authority | Interagency Contracting Authority | 7E | Indicates whether the transaction is an Economy Act or Statutory Authority | char(1) |
This section shows whether various legislative mandates apply to the award.
Data Field | FPDS Screen Name | FPDS Element Number | Description/FPDS Definition | Field Type |
---|---|---|---|---|
Walsh-Healy Act | Walsh-Healy Act | 7B | Indicates whether the transaction is subject to the Walsh-Healy Act (passed in 1936, establishing overtime as hours worked in excess of 40 hours per week). | char(1) |
Service Contract Act | Service Contract Act | 7C | Indicates whether the transaction is subject to the Service Contract Act (concerning payment of prevailing wage rates and fringe benefits to service employees). | char(1) |
Davis-Bacon Act | Davis Bacon Act | 7D | Indicates whether the transaction is subject to the Davis-Bacon Act (concerning the payment of prevailing wages on public works projects). | char(1) |
Clinger-Cohen Act | Clinger-Cohen Act | 7A | Indicates the funding office has certified that the information technology purchase meets the planning requirements in 40 USC 1422 and 1423. | char(1) |
Other Statutory Authority | Other Interagency Contracting Statutory Authority | 7F | Indicates whether the transaction is subject to other statutory authority (i.e., legislation other than the Economy Act). | text |